'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel CSV Import Showing Garbled Data or Accessibility Unavailable
Question details
The user needs to correctly import a downloaded CSV file into Excel for Tableau dashboards, but the file currently displays incorrect data and triggers an accessibility unavailable error.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening downloaded CSV data intended for integration with Tableau dashboards.
- Observed behavior
- The data appears garbled or incorrectly formatted across columns, accompanied by an Accessibility unavailable error message.
Ensure your downloaded CSV file is completely saved on your local drive and hasn't been accidentally modified. It is highly recommended to open the file in a basic text editor like Notepad first to verify the raw data is not fundamentally corrupted.
Use the Get Data Feature to Import the CSV File
Importing the CSV file through the Data tab instead of directly double-clicking it allows you to manually set the correct character encoding and delimiter, ensuring clean data.
Directly opening a CSV file forces Excel to guess the file origin and delimiters based on your system's default regional settings. This often results in garbled text for UTF-8 files or data crammed into a single column.
Launch Excel and create a completely blank workbook to serve as the destination for your imported data.
Click on the "Data" tab located on the top ribbon, then select "Get Data" > "From File" > "From Text/CSV".
Browse your computer for the problematic downloaded CSV file, select it, and click "Import".
In the preview window, change the "File Origin" dropdown to "65001: Unicode (UTF-8)" to resolve any garbled characters. Then, ensure the "Delimiter" dropdown matches the character used in your file (such as Comma, Semicolon, or Tab).
Verify that the data looks correct in the preview pane, then click "Load" to bring the cleanly formatted data into your Excel worksheet.
Inspect the Raw CSV File in a Text Editor
If Excel still fails to import the data properly, inspecting the raw text can reveal unexpected delimiters, special characters, or underlying file corruption.
Import and Manage CSV Data Flawlessly with WPS Spreadsheet
WPS Spreadsheet provides an incredibly intuitive Data Import wizard that seamlessly detects file encoding and delimiters, preventing garbled text and formatting errors. It is a highly compatible, lightweight alternative to Microsoft Excel for handling extensive data meant for tools like Tableau.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a new blank spreadsheet document.
- 2. Initiate data import: Go to the "Data" tab on the main ribbon and click on "Import Data".
- 3. Select your CSV file: Choose the CSV file you downloaded and follow the intuitive Text Import Wizard.
- 4. Configure encoding and delimiters: Ensure "Delimited" is selected, set your file origin to UTF-8, and choose the correct delimiter (like Comma).
- 5. Finish the import: Preview the clean columns to ensure accuracy, then click "Finish" to populate your spreadsheet.
Frequently Asked Questions
Why does Excel show an 'Accessibility unavailable' error when opening a CSV?
This error frequently occurs when Excel's accessibility checker fails to process the file's structure. This happens if the file has unexpected character encoding (like UTF-8 without BOM), non-standard delimiters, or minor file corruption. Importing the file properly via the Data tab bypasses this background check and reads the raw text cleanly.
Why does my CSV data appear crowded into a single column?
This happens when the delimiter used in your CSV file (such as a semicolon or pipe) does not match your computer's default regional list separator (which is usually a comma in the US). By using the "Get Data" or "From Text/CSV" feature, you can manually instruct Excel on which delimiter to use to properly split the data into multiple columns.
How do I ensure my CSV file is saved in UTF-8 format in Excel?
Once you have successfully imported and formatted your data in Excel, go to File > Save As. In the 'Save as type' dropdown menu, select 'CSV UTF-8 (Comma delimited) (*.csv)' instead of the standard CSV option. This guarantees special characters are preserved for external tools.
Will fixing the CSV encoding in Excel affect my Tableau dashboards?
No, fixing the encoding will actually improve your Tableau experience. By importing the CSV cleanly using UTF-8 and saving it without garbled characters, Tableau will be able to read the data source accurately without throwing encoding errors or misinterpreting text fields.
