Why Won’t My Fabric File Fully Open in Excel?

Although a .csv file is defaulted to open in Excel, it is not actually an Excel file, it’s a comma separated value file and a flat file.  The flat file can contain any number of records, but an Excel sheet only has 1,048,576 rows, so any rows beyond that cannot be viewed in Excel.  This may give you the impression that you did not receive all of your data but that is not the case.  It is a limitation of Excel. 

If you want to quickly view how many rows are in your data, you can right click on the file and open it in a text editor, like Notepad.  This will show you all of your data, but it is difficult to work with or analyze the data in that type of program.   

In order to easily manipulate all of the data, you’ll need to import it to a database management tool, such as Microsoft Access, Microsoft SQL Server, or PostgreSQL.  Please see links below with instructions on how to load a .csv file into these tools.  In all cases, the delimiter is a comma.    

Here are instructions for how to import a .csv into Microsoft Access:  https://www.quackit.com/microsoft_access/microsoft_access_2016/tutorial/import_data_into_microsoft_access.cfm 

Here are instructions for how to import a .csv into SQL Server: https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-flat-file-wizard?view=sql-server-ver15 

Here are instructions for how to import a .csv into PostgreSQL: https://dataschool.com/learn-sql/importing-data-from-csv-in-postgresql/

If you need additional technical support, please use the “Submit a Request” button in the top right-hand corner to file a request for help.   


Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Video Resources
Key Reference Documents
BDC User Guide and Data Specifications
Form 477 Resources
Get Help