Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel File Greater than 40 MB

    Hi,

    My datafile in MS excel is greater than 40 MB and hence, I am not able import it in STATA (Version 14 MP Parallel Edition). Please guide as to how can I resolve this issue.

    Thanks
    Last edited by Prateek Bedi; 29 Oct 2018, 08:38.

  • #2
    Two suggestions:
    1. Export the XLSX as a CSV, then import the CSV into Stata.
    2. See this undocumented setting (and accompanying warning) that allows you to bypass the size check.

    Comment


    • #3
      The 40 MB limit only applies to XLSX files, not to the older format XLS. If you can convert the file to XLS, you should be able to import your data.

      Alternately, especially if you don't have Excel to convert the file, you might use the Pandas Python library to import and the export to another format (see the read_excel and to_stata functions). You may do that with any other package able to import Excel files and to export something readable by Stata.

      Nils Enevoldsen I'm very happy to learn about this setting!

      Comment


      • #4
        Thanks a lot Nils Enevoldsen and Jean-Claude Arbaut. Your solutions worked for me. Really appreciate your help!!

        Comment

        Working...
        X