Newsroom Update

Beginning in May, a special Today at Apple series titled “Made for Business” will offer small business owners and entrepreneurs free opportunities to learn how Apple products and services can support their growth and success. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

converting .dat to .csv on ipad

I download spreadsheets that are in zip files. When I decompress them they are .dat files. On the iPad I cannot work with.dat files. In Numbers and Excel on Mac or Windows it is easy to change the file name to .csv and the respective program will open the spreadsheet as .csv.

Is there a way to do the same on iPad. When I decompress the file I get a .dat file that I can neither open or change the file format. Thank you in advance.

iPad Air 3 Wi-Fi

Posted on Jan 2, 2023 6:30 PM

Reply
Question marked as Best reply

Posted on Jan 3, 2023 7:26 AM

First, you perhaps need to understand that “.dat” files are often application-specific data - that is not necessarily intended to be human readable; these files may require the App that created them to open or import data from them.


Assuming that the files that you wish to import are actually comma-delimited data (i.e., a “.csv” file), changing the file extension may make the file readable by other Apps and programs.


With release of iOS/iPadOS16.x, the native iOS/iPadOS Files App now allows you to see the full filename and associated file-extension - and freely alter the filename and extension information. The tags appended to your post suggest that you have an iPad Air3 - this model being capable of update to iPadOS16.


Once updated to iPadOS 16.2 (this being the most recent release), you’ll be able to manipulate the filename extension; if your “.dat” files are actually “.csv” files, you’ll be able to easily resolve your immediate difficulty, allowing your spreadsheet data to be imported by the Numbers App.

3 replies
Question marked as Best reply

Jan 3, 2023 7:26 AM in response to tennislord

First, you perhaps need to understand that “.dat” files are often application-specific data - that is not necessarily intended to be human readable; these files may require the App that created them to open or import data from them.


Assuming that the files that you wish to import are actually comma-delimited data (i.e., a “.csv” file), changing the file extension may make the file readable by other Apps and programs.


With release of iOS/iPadOS16.x, the native iOS/iPadOS Files App now allows you to see the full filename and associated file-extension - and freely alter the filename and extension information. The tags appended to your post suggest that you have an iPad Air3 - this model being capable of update to iPadOS16.


Once updated to iPadOS 16.2 (this being the most recent release), you’ll be able to manipulate the filename extension; if your “.dat” files are actually “.csv” files, you’ll be able to easily resolve your immediate difficulty, allowing your spreadsheet data to be imported by the Numbers App.

converting .dat to .csv on ipad

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.